\section{Question 1F}

\begin{figure}[htp]
	\centering
	\includegraphics[width=\textwidth]{q1f-data-model.pdf}
	\caption{Data Model}\label{fig:q1f-data-model}
\end{figure}

\noindent The data model is quite simple. There are two tables, \verb!Issue! and \verb!Customer!.

\verb!Customer! contains all of the customers who have accounts reistered on the system. The customer has a username and password, which are used for the web interface, as well as information for technician assignment, like Full Name, Telephone Number and Address. The user's internet address is also stored for notifications, communication, and password recovery.

There is a one to many relationship between \verb!Customer! and \verb!Issue!, called \verb!has!. This represents the fact that each customer can have many issues open, and each issue was opened by one customer.

\verb!Issue! contains all of the issues in the system. They have a Description, as given by the customer when the issue was registered, and the registration date is also stored. Issues have an indentifying number, a status (\textit{`open'}, \textit{`pending'} or \textit{`fixed'}), and a priority, set by PC Gurus staff.
